Add dBase files (*.dbf)  to Access with its indexes (*.idx  and *.cdx)

Hello!

I need to add dbf files in Access. These tables have indexes *idx or *cdx . How can I set those indexes in Access to my added dbf

July 15th, 2013 6:58am

Hi,

Based on my research, when you link or open a FoxPro or dBASE file, you can also tell Microsoft Access to use one or more FoxPro index (.IDX or .CDX) files or dBASE index (.NDX or .MDX) files to improve performance. Microsoft Access keeps track of the indexes in a special information (.INF) file. When you use Microsoft Access Basic to link or open a FoxPro or dBASE file, you must create the .INF file yourself using a text editor. The name of the .INF file must correspond to the name of the external table. For ease of locating associated indexes, it's best to put the .INF file in the same directory as the associated table. If, however, the table is on a read-only share, you can specify a different path using the INFPath entry in the XBASE folder in the HKEY_LOCAL_MACHINE \SOFTWARE \MICROSOFT \JET \3.0\ENGINES registry setting.

Quote from:

http://technet.microsoft.com/en-us/library/cc722917.aspx

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2013 3:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics